Statistics on Partitioned Tables

Comments 0

Share to social media

When Jonathan Lewis decided it was time to post a list of the Partition Stats posts on his blog and Noons suggested I made them easier to track down, I listened. So this post will link to the others and, at least in the short term, I’ve also included links in the side-bar on my Oracle blog.

Part 1 – Default options – GLOBAL AND PARTITION

Part 2 – Estimated Global Stats

Part 3 – Stats Aggregation Problems I

Part 4 – Stats Aggregation Problems II

Part 5 – Minimal Stats Aggregation

Part 6a – COPY_TABLE_STATS – Intro

Part 6b – COPY_TABLE_STATS – Mistakes

Part 6c – COPY_TABLE_STATS – Bugs and Patches

Part 6d – COPY_TABLE_STATS – A Light-bulb Moment

Load comments

About the author

Doug Burns

See Profile

Doug is an Oracle 9i Certified Professional DBA with 17 years experience in a wide range of environments, and has used Oracle versions 6.0 through to 10g on a number of different operating systems. He has developed and taught Oracle PL/SQL, Performance Tuning and DBA courses for Learning Tree International and Oracle UK in the past, and is an active contributor to the UK Oracle User Group. He has written and presented technical papers at conferences in the U.S.A., UK, Europe and Middle East, which are available at his website, and is a member of the Oak Table Network and an Oracle ACE.

Doug Burns's contributions